CREATE TABLE [dbo].[JOL_SurveyManagement_Theme]
(
[id] [int] NOT NULL IDENTITY(1, 1),
[topic] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL,
[type] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[add_time] [smalldatetime] NULL,
[user_add] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[update_time] [smalldatetime] NULL,
[user_update] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[visit_times] [int] NULL,
[start_time] [smalldatetime] NULL,
[end_time] [smalldatetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[JOL_SurveyManagement_Theme] ADD CONSTRAINT [PK_JOL_SurveyManagementTheme] PRIMARY KEY CLUSTERED  ([id]) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'MS_Description', N'调查结束时间', 'SCHEMA', N'dbo', 'TABLE', N'JOL_SurveyManagement_Theme', 'COLUMN', N'end_time'
GO
EXEC sp_addextendedproperty N'MS_Description', N'调查开始时间', 'SCHEMA', N'dbo', 'TABLE', N'JOL_SurveyManagement_Theme', 'COLUMN', N'start_time'
GO
EXEC sp_addextendedproperty N'MS_Description', N'调查的标题', 'SCHEMA', N'dbo', 'TABLE', N'JOL_SurveyManagement_Theme', 'COLUMN', N'topic'
GO
EXEC sp_addextendedproperty N'MS_Description', N'类型', 'SCHEMA', N'dbo', 'TABLE', N'JOL_SurveyManagement_Theme', 'COLUMN', N'type'
GO
EXEC sp_addextendedproperty N'MS_Description', N'浏览次数', 'SCHEMA', N'dbo', 'TABLE', N'JOL_SurveyManagement_Theme', 'COLUMN', N'visit_times'
GO
